home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Collection of Tools & Utilities
/
Collection of Tools and Utilities.iso
/
dbase
/
dbfed120.zip
/
DBFEDIT.DOC
next >
Wrap
Text File
|
1990-09-15
|
120KB
|
3,181 lines
D B F E D I T
D b a s e E d i t o r
CopyRight (C) 1989, 1990 by Preston Lau
Version 1.2
FOR EVALUATION ONLY!
September 1990
R E F E R E N C E M A N U A L
1309 Spring Street
Apt. 303
Madison, WI 53715
(608) 257 - 0233
Dbase Editor
T A B L E O F C O N T E N T S
-----------------------------------
1. License Information
2. Registration Form
3. Introduction
4. Features
5. Requirements
6. Running the Program
7. Special features in DBFEDIT
(a) The Status Line
(b) Pull-Down Menu
(c) Moving around in the database
(d) Block Commands
(e) Window Commands
(f) Edit and Append Record
(g) Cut and Paste
(h) Statistical Functions
(i) Sort File
(j) Filter File
(k) Graph Plotting
(l) Special Commands
Dbase Editor
L I C E N S E I N F O R M A T I O N
--------------------------------------
This program is a 'shareware' program.
It represens many, many hours of work. You are granted a limited
license to make copies of the program distribution diskettes
for the sole purpose of evaluation. If, after 10 days, you find
that the program meet your needs, you are expected to pay the
registration fee of $30.00 per copy. Registered users will
receive the latest version of DBFEDIT by mail. There will be
many new features coming in the next version, so please
register NOW!!! All the coming features will be described later!!
However, if you do not find the program of value, you must
discontinue to use the program after the trial period. You are
encouraged to make complete copies of the original distribution
diskettes to other interested people.
Checks should be made payable to Preston Lau and mailed to me at:
1309 Spring Street
Apt. 303
Madison, WI 53715
U.S.A.
A convenient mailer form is shown below.
If you have any problem, just send me a letter.
Every effort is made to support registered users.
^^^^^^^^^^
If you are in Madison, you can also contact me through the
following BBS:
DILHR
Madison PC User Group
Selene
My user name of the above BBS is Preston Lau
or you can send e-mail to me through the following address
wun@garfield.cs.wisc.edu
Dbase Editor
DBFEDIT Version 1.2
Copyright (C) 1989, 1990 by Preston Lau
Registration Form
------------------
Date_________________
Name_________________________________________________________________
Address______________________________________________________________
City_________________________________State____________Zip____________
Telephone Number (Voice)_____________________(Data)__________________
QTY AMOUNT TOTAL
Basic Registration ____ $30.00 ea ___.__
(include documentation on disk, author support)
Std. Shipping & Handling (U.S.A.) $ 3.00
Overseas orders add $5.00 $ ___.__
---------------
Total Enclosed (Check or Money Order ONLY) $ ___.__
Diskette ( 3 1/2 or 5 1/4 ) Circle one.
Make checks payable to: Preston Lau
Mail to: 1309 Spring Street
Apartment 303
Madison, WI 53715
U.S.A.
Your Suggestions or comments :
1)
_____________________________________________________________________
2)
_____________________________________________________________________
3)
_____________________________________________________________________
4)
_____________________________________________________________________
5)
_____________________________________________________________________
6)
_____________________________________________________________________
7)
_____________________________________________________________________
Dbase Editor
I N T R O D U C T I O N
-----------------------
Dbase Editor is designed to access and edit multiple database
files created by the program Clipper, Dbase III Plus, Dbase IV
or FoxPro. This program is mainly written in Turbo C 2.0 and it
make use of Full windowing functions and pop down menu in order
to help the novice users.
You can use DBFEDIT to:
- View and edit several database files at the
same time.
- Cut and Paste between different database
files and different fields
- Sort the database in any fields order
- Reorder fields for edit and append function
- View the file structure
- Send the file structure to a printer
- Mark a block for delete and recall
- Delete and Recall a block of records
- Copy a block of records in the same file
- Print a block of records
- Draw a line graph on a block of records
- Draw a bar graph on a block of records
- Draw a stack graph on a block of records
- Draw a HILO graph on a block of records
- Draw a Cubic Spline Curve on a block of records
- Save the block of record as ASCII text file.
- Search a file for certain string
- Change the default color.
- Use a pop-up calculator.
- Calculate the sum.
- Calculate the mean.
- Calculate the maximum and minimum.
- Calculate the standard deviation.
- Calculate the variance.
- Calculate the mode.
- View an index expression of an index file.
- Copy file structure to another file.
- Filter a record.
- View the filter expression.
- Append a record
- Goto anywhere in the database through the use
of simply key combinations.
- Delete a record
- Recall a record
- Exit to DOS shell
I hope you will find them useful.
Dbase Editor
F E A T U R E S
---------------
In the following paragraphs, I will describe some of the special
features you will enjoy while using DBFEDIT:
- Full Windowing Features. You can open, close or go to
a particular window easily. You can also resize or move
any window you like.
- Browse at most 20 database files at the same time with
windows that you can change their size or move it anywhere.
- Allow you to sort the database file and save it to the disk
in another name. You can specify the order of fields that
you want to sort.
- Plot a graph of several fields in the database.
At most 7 fields can be plot on a graph at the same time.
You can compare values in different fields easily.
Five types of graph are provided at this time. They are
line graph, bar graph, stack graph, HILO graph and
Cubic Spline Curve.
- A cut and paste function is provided to copy one field
to another between different database files.
- Mark any block of records for deleting, recalling
and printing. You can also copy block of records from
one position to another position in the same file.
- Pop-up a calculator to do simple calculation. (+, -, *, /, %)
- Do simple statistical calculation, such as sum, mean, mode,
standard deviation, variance, maximum and minimum.
- A pull-down menu is install to help the novice user,
by pressing a <ESC> key, the menu will pop up and allow
you to choose the command you want to execute.
Dbase Editor
- A Pop-Up directory allows you to choose the file. With this
particular features, you can choose any file in your
harddisk or floppy disk easily.
- You can print the file structure you are editing with
good formatted output. Or, you can see it on the screen.
- Change the windows to your favorite colors.
You can load the old color set or save the new color
set as you like.
- View the index expression of a particular index file.
You can choose the index file from the pop-up directory.
- Copy the structure of the current file to another
database for further use.
- Filter a file for certain record and view the
filter expression on screen.
- An on-screen help is also available. As usual, you can
press <F1> to pop-up the help window.
- Allows temporary exit to DOS (or usually called DOS shell)
You can execute other program when you are running DBFEDIT.
- Faster performance than the Dbase III+ or Dbase IV
- Easy to use. No need to remember any command. You can use
the pull-down menu or press F1 to see an on-screen help.
Dbase Editor
R E Q U I R E M E N T S
-----------------------
DBFEDIT will run on the IBM PS/2, PC/AT, PC/XT, PC and on
IBM compatible computers including the Compaq, NCR, Tandy 1000,
and WYSE PC's. Minimum requirements are:
PC-DOS or MS-DOS 2.0 or greater.
One diskette drive. (hard disk is preferred)
An EGA monitor
or
A monochrome monitor with 80-column display
(You cannot see the colorful window using a monochrome monitor)
Dbase Editor
R u n n i n g t h e P r o g r a m
-------------------------------------
To run the DBFEDIT, you can simply type
C>dbfedit
at the DOS prompt. The progrm will automatically check whether
the monitor you are using is a monochrome or an EGA monitor.
If you are using some kind of plasma screen (Laptop user).
Then you have to pass the parameter /mono to the program
to force the monochrome display. i.e.
C>dbfedit /mono
Note that if this is the first time you run the program,
the program will check your monitor type and save the
corresponding color set to the disk in the save directory
as the program. The config filename is dbfedit.cfg. After
changing the window color to your favourate color, you can
save the result to the disk by choosing <Save Config> in
the pull-down menu. Later if you want to change your monitor
type, you can delete the file dbfedit.cfg and when you run
the program again, it will create the config file again with
the new monitor type.
Dbase Editor
After the program started, you can see the following logo.
(Actually in inverse attribute)
--------------------------------------------------------------------------------
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░╒═══════════════════════════════════════════════════════════╕░░░░░░░░░
░░░░░░░░░░│ Dbase Editor Version 1.2 │░░░░░░░░░
░░░░░░░░░░│ │░░░░░░░░░
░░░░░░░░░░│ Copyright (C) 1989, 1990 Preston Lau │░░░░░░░░░
░░░░░░░░░░│ │░░░░░░░░░
░░░░░░░░░░│ Serial number : not registered! │░░░░░░░░░
░░░░░░░░░░│ │░░░░░░░░░
░░░░░░░░░░╘═══════════════════════════════════════════════════════════╛░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░╒══════════════════════════════════════════════════════════════════════╕░░░░
░░░░│ If you find any problem with the program, feel free │░░░░
░░░░│ to send me a letter to the following address : │░░░░
░░░░│ │░░░░
░░░░│ 1309 Spring Street │░░░░
░░░░│ Apartment 303 │░░░░
░░░░│ Madison, WI 53715 │░░░░
░░░░│ Thank you very much for your support. │░░░░
░░░░│ │░░░░
░░░░│ Press any key to continue │░░░░
░░░░╘══════════════════════════════════════════════════════════════════════╛░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
--------------------------------------------------------------------------------
You can now press any key to continue.
Dbase Editor
After pressing a key, the program will ask you the name of
file you want to edit. At this time you can enter the file
name which is in the default directory.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : Total :
╔══════════════════════════════ Get File ══════════════════════════════╗
║ ║
║ Name of file to READ : sample1.dbf ║
║ ║
╚══════════════════════════════════════════════════════════════════════╝
Press <Up Arrow> or <Down Arrow> to choose the file
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit ", color.foot, 24, 0);
--------------------------------------------------------------------------------
If you want to pass the file name when running the program
instead of entering it in the program, you can do the following
C>dbfedit sample1.dbf
where sample1.dbf is one of the sample database file provided in
the package. If you miss out the .dbf like this
C>dbfedit sample1
then the program will automatically add the extension .dbf to
the end of the filename.
Dbase Editor
If you want also to force the monochrome display, you can type
the following:
C>dbfedit /mono filename.ext
You should note that the parameter /mono must be the first
parameter you pass to the program.
If the filename you gave is not a valid filename or that
file is not exist or that file is not a Dbase file.
Then an error message will pop up and ask you for another name.
At that time, you can enter the correct filename or press
<ESC> to abort the program execution and return to DOS.
┌──────────── Message ────────────┐
│ This is not a DBASE format file │
│ ╔════╗ │
│ ║ OK ║ │
│ ╚════╝ │
└─────────────────────────────────┘
Dbase Editor
Actually, there is another easy way to choose the file
you want to edit. Press <Up Arrow> or <Down Arrow> when
the program ask you to enter the filename. A pop up
window will appear with all the filename in the default
directory. To choose, you simply use <Up Arrow> and
<Down Arrow> to move about and press <RETURN> to choose
the highlighted filename.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : Total :
┌─── Files ────┐
│ =DRIVE=
│ <.> ░
│ <..> ▒
│ <SQLHOME> ▒
│ <SAMPLES> ▒
│ <SOURCE> ▒
╔══════════════════════════════│ SAMPLE1.DBF ▒════════════════════════╗
║ │ SAMPLE2.DBF ▒ ║
║ Name of file to READ : │ TEST.DBF ▒ ║
║ │ FLIGHT1.DBF ▒ ║
╚══════════════════════════════│ FLIGHT2.DBF ▒════════════════════════╝
│ FLIGHT3.DBF ▒
│ ▒
│ ▒
│
└──────────────┘
C:\DBFEDIT\
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
In the above diagram, choosing =DRIVES= allow you to choose a
drive letter.
<.> means the current directory. Choosing it mean nothing
because you are already in current directory.
<..> means the previous directory. Choosing it will move
you back one directory.
<SQLHOME> and <SAMPLES> are the directories. Choosing it
will move you to that directory.
SAMPLE1.DBF, SAMPLE2.DBF and .... are the filename you can
choose to edit.
Dbase Editor
To change the default drive name. You have to choose the
option "=DRIVE=" from the listing. After choosing it, a window
will pop up asking you the drive you want to change to. You can
now use arrow keys, <TAB>, <SPACE> to move to the final drive
letter. To confirm your selection, you have to press <ENTER> once.
To abort the operation, you can press <ESC> to return to the
previous window.
Shown below is a sample output screen.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : Total :
┌─── Files ────┐
│ =DRIVE=
│ <.> ░
│ <..> ▒
│ <SQLHOME> ▒
┌───────────────────────────────────────┐
│ Press <Enter> to accept │
╔═══════════════│ Press <ESC> to abort │══════════════╗
║ │ │ ║
║ Name of file│ ┌───┐ ┌───┐ ╔═══╗ ┌───┐ ┌───┐ ┌───┐ │ ║
║ │ │ A │ │ B │ ║ C ║ │ D │ │ E │ │ F │ │ ║
╚═══════════════│ └───┘ └───┘ ╚═══╝ └───┘ └───┘ └───┘ │══════════════╝
│ Select Drive using arrows │
└───────────────────────────────────────┘
│ ▒
│
└──────────────┘
C:\DBFEDIT\
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
If you accidentally choose a not ready drive from the list,
an error message will pop up. Just press any key to choose
another valid drive letter for database reading.
┌────────────────────── Message ──────────────────────┐
│ Drive A is not ready. Choose another drive please. │
│ ╔════╗ │
│ ║ OK ║ │
│ ╚════╝ │
└─────────────────────────────────────────────────────┘
Dbase Editor
Shown below is a sample screen editing a file.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PHONIX SAUCE 5OZX12
║LEE SENG HING SAUCE 650MLx18 ▒
║LEE SENG HING SAUCE 340MLx36 ▒
║GAI FAT HONG POWDER 6LBX6 ▒
║YAU SHING HONG NOODLE CUP ▒
║SUN FUNG PROVISIONS S.FISH ▒
║TAI SHING PROVISIONS D.SQUID ▒
║CHAN YEE JAI CAKE ALMOND ▒
║AU'S FL 365-6 ▒
║ON LEE NOODLE 500GX50 ▒
║TIEN CHU SAUCE 650MLX24 ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
T h e S t a t u s L i n e
-----------------------------
Under the header there is a one line status line.
--------------------------------------------------------------------------------
Current : 46 Del C:\DBFEDIT\SAMPLE1.DBF Total : 63
--------------------------------------------------------------------------------
| | | |
| | | |
| | | |
| | | This shows the total record number
| | | of the active database file.
| | |
| | |
| | This shows the path and filename of the active
| | database file.
| |
| |
| This shows the status of the current record whether it is
| deleted or not. If the current record (highlighted bar) is
| already deleted, then it will show "Del", otherwise, it will
| show nothing!
|
|
This shows the current record no. of the active database file.
Dbase Editor
P u l l - D o w n M e n u
---------------------------
When you press <ESC>, there will be a pull-down menu
appear on the top part of the screen. Most of the functions
you use in this editor can be found in the pull-down menu.
In the following, I will list all the commands in each menu.
1) Open File - Open a new database file.
2) Close File - Close a database file.
3) Save as text - Save the marked block of records in the
current database to a text file.
4) View Index - View the index expression of an index file.
5) Help - A on-screen help.
6) Shell - Go to the DOS prompt.
7) Quit - Quit the Program and return to DOS.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
┌──────────────────────────────────────────────────────────────────────────────┐
│ File Window Edit Goto Block Search Options Math │
└───┌────────────────┐─────────────────────────────────────────────────────────┘
║LEE│ Open File │E 650MLx18 ▒
║LEE│ Close File │E 340MLx36 ▒
║GAI│ Save as text │ER 6LBX6 ▒
║YAU│ View Index │LE CUP ▒
║SUN│ Help │ISIONS S.FISH ▒
║TAI│ sHell │ISIONS D.SQUID ▒
║CHA│ Quit │ ALMOND ▒
║AU'└────────────────┘ 365-6 ▒
║ON LEE NOODLE 500GX50 ▒
║TIEN CHU SAUCE 650MLX24 ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
1) Previous - Go to Previous Window.
2) Next - Go to Next Window.
3) Goto - Goto any Window by filename.
4) Resize - Resize the current Window.
5) Move - Move the current Window.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
┌──────────────────────────────────────────────────────────────────────────────┐
│ File Window Edit Goto Block Search Options Math │
└──────────┌────────────┐──────────────────────────────────────────────────────┘
║LEE SENG H│ Previous │ 650MLx18 ▒
║LEE SENG H│ Next │ 340MLx36 ▒
║GAI FAT HO│ Goto │ 6LBX6 ▒
║YAU SHING │ Resize │ CUP ▒
║SUN FUNG │ Move │ONS S.FISH ▒
║TAI SHING └────────────┘ONS D.SQUID ▒
║CHAN YEE JAI CAKE ALMOND ▒
║AU'S FL 365-6 ▒
║ON LEE NOODLE 500GX50 ▒
║TIEN CHU SAUCE 650MLX24 ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
1) Cut Field - Cut a field of the marked block of records
in the current database.
(This function is not available for non registered user)
2) Paste Field - Paste the field cut previously starting
from the current record.
(This function is not available for non registered user)
3) Edit Current Record - Edit highlighted record.
4) Append records - Append mutiple records to the current
database file.
5) Change Order - This change the order of the fields shown on
the screen during the EDIT and APPEND function.
6) Delete/Recall record - Delete or Recall the current record.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
┌──────────────────────────────────────────────────────────────────────────────┐
│ File Window Edit Goto Block Search Options Math │
└───────────────────┌────────────────────────┐─────────────────────────────────┘
║LEE SENG HING SA│ Cut field │ ▒
║LEE SENG HING SA│ Paste field │ ▒
║GAI FAT HONG PO│ Edit current record │ ▒
║YAU SHING HONG NO│ Append record │ ▒
║SUN FUNG PR│ change Order │ ▒
║TAI SHING PR│ Delete/recall record │ ▒
║CHAN YEE JAI CA└────────────────────────┘ ▒
║AU'S FL 365-6 ▒
║ON LEE NOODLE 500GX50 ▒
║TIEN CHU SAUCE 650MLX24 ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
1) Goto any record - Goto any record in the current
file by record number.
2) Top of file - Goto top of the file in the current window.
3) Bottom of file - Goto bottom of the file in the current window.
4) Top Screen - Goto top of the screen in the current window.
5) Bottom Screen - Goto bottom of the screen in the current
window.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
┌──────────────────────────────────────────────────────────────────────────────┐
│ File Window Edit Goto Block Search Options Math │
└──────────────────────────┌────────────────────┐──────────────────────────────┘
║LEE SENG HING SAUCE │ Goto any record │ ▒
║LEE SENG HING SAUCE │ Top of file │ ▒
║GAI FAT HONG POWDER │ Bottom of file │ ▒
║YAU SHING HONG NOODLE │ toP of screen │ ▒
║SUN FUNG PROVISION│ bottoM of screen │ ▒
║TAI SHING PROVISION└────────────────────┘ ▒
║CHAN YEE JAI CAKE ALMOND ▒
║AU'S FL 365-6 ▒
║ON LEE NOODLE 500GX50 ▒
║TIEN CHU SAUCE 650MLX24 ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
1) Mark Beginning Block - Mark the begining of the block.
2) Mark Ending Block - Mark the end of the block.
3) Mark All records - Mark all the record in the current file.
4) Hide/Display Block - Hide/Display the current marked block.
5) Delete Marked Block - Delete the current highlighted block.
6) Recall Marked Block - Delete the current highlighted block.
7) Copy Marked Block - Copy the current highlighted block.
8) Print Block - Print the current highlighted block.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
┌──────────────────────────────────────────────────────────────────────────────┐
│ File Window Edit Goto Block Search Options Math │
└─────────────────────────────────┌────────────────────────┐───────────────────┘
║LEE SENG HING SAUCE │ mark Beginning block │ ▒
║LEE SENG HING SAUCE │ mark Ending block │ ▒
║GAI FAT HONG POWDER │ mark All records │ ▒
║YAU SHING HONG NOODLE │ Hide/display block │ ▒
║SUN FUNG PROVISIONS │ Delete marked block │ ▒
║TAI SHING PROVISIONS │ Recall marked block │ ▒
║CHAN YEE JAI CAKE │ Copy marked block │ ▒
║AU'S FL │ Print marked block │ ▒
║ON LEE NOODLE └────────────────────────┘ ▒
║TIEN CHU SAUCE 650MLX24 ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
1) Sort File - This function allow sorting of a database
file ordered by any combination of fields.
2) Search File - Search the file for a string.
3) Search Next - Continue to search the string in the file.
4) Filter File - Filter the file for certain condition.
5) Filter Next - Goto next record satisfying the condition.
6) Show Expression - View the filtering expression on the screen.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
┌──────────────────────────────────────────────────────────────────────────────┐
│ File Window Edit Goto Block Search Options Math │
└─────────────────────────────────────────┌───────────────────┐────────────────┘
║LEE SENG HING SAUCE 650MLx1│ Sort file │ ▒
║LEE SENG HING SAUCE 340MLx3│ sEarch file │ ▒
║GAI FAT HONG POWDER 6LBX6 │ seArch next │ ▒
║YAU SHING HONG NOODLE CUP │ Filter file │ ▒
║SUN FUNG PROVISIONS S.FISH │ fIlter next │ ▒
║TAI SHING PROVISIONS D.SQUID│ sHow expression │ ▒
║CHAN YEE JAI CAKE ALMOND └───────────────────┘ ▒
║AU'S FL 365-6 ▒
║ON LEE NOODLE 500GX50 ▒
║TIEN CHU SAUCE 650MLX24 ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
1) Get Info - Get the information of the current file.
2) Print Info - Print the information of the current file.
3) Copy Structure - Copy the structure of the current
file to another file.
4) Change Color - Change the color setting of the program.
5) Load Config - Load the color setting from the disk.
6) Save Config - Save the color setting to the disk.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
┌──────────────────────────────────────────────────────────────────────────────┐
│ File Window Edit Goto Block Search Options Math │
└──────────────────────────────────────────────────┌──────────────────┐────────┘
║LEE SENG HING SAUCE 650MLx18 │ Get info │ ▒
║LEE SENG HING SAUCE 340MLx36 │ Print info │ ▒
║GAI FAT HONG POWDER 6LBX6 │ Copy structure │ ▒
║YAU SHING HONG NOODLE CUP │ cHange color │ ▒
║SUN FUNG PROVISIONS S.FISH │ Load config │ ▒
║TAI SHING PROVISIONS D.SQUID │ Save config │ ▒
║CHAN YEE JAI CAKE ALMOND └──────────────────┘ ▒
║AU'S FL 365-6 ▒
║ON LEE NOODLE 500GX50 ▒
║TIEN CHU SAUCE 650MLX24 ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
1) Calculator - Pop-up a on-screen calculator.
2) Max & Min - Calculate the maximum and minimum value in
the current file.
3) Sum & Mean - Calculate the Sum and Mean in the current file.
4) Std.Dev & Variance - Calculate the standard deviation and
the variance in the current file.
5) Mode - Calculate the mode of any field in the current file.
6) Change Graph Title - Change the name of title, x-axis and
and y-axis of the graph.
7) Draw line Graph - Plot a line graph of the current database file.
8) Draw bar Graph - Plot a bar graph of the current database file.
(This function is not available for non registered user)
9) Draw stack Graph - Plot a stack graph of the current database file.
(This function is not available for non registered user)
10) Draw HILO Graph - Plot a HILO graph of the current database file.
(This function is not available for non registered user)
11) Draw Cubic Spline Graph - Plot a cubic spline graph of the
current database file.
(This function is not available for non registered user)
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
┌──────────────────────────────────────────────────────────────────────────────┐
│ File Window Edit Goto Block Search Options Math │
└────────────────────────────────────────────────────┌────────────────────────┐┘
║LEE SENG HING SAUCE 650MLx18 │ Calculator │▒
║LEE SENG HING SAUCE 340MLx36 │ Max & min │▒
║GAI FAT HONG POWDER 6LBX6 │ Sum & mean │▒
║YAU SHING HONG NOODLE CUP │ sTd. dev. & variance │▒
║SUN FUNG PROVISIONS S.FISH │ Mode │▒
║TAI SHING PROVISIONS D.SQUID │ cHange graph title │▒
║CHAN YEE JAI CAKE ALMOND │ draw Line graph │▒
║AU'S FL 365-6 │ draw Bar graph │▒
║ON LEE NOODLE 500GX50 │ draw stAck graph │▒
║TIEN CHU SAUCE 650MLX24 │ draw HILO graph │░
║SHING CHEONG WICKS WICKS │ draw cubic sPline │▒
║LAIN LAIN PRAWN CRACKERS GP └────────────────────────┘▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
Moving around in the database
-----------------------------
DBFEDIT provide easy way for you to move around in the
database. You can move one line or one page, or you can
go to specific record in the database. In the following,
I will describe all the command you can use to move around
in the database.
1) <PgUp>
Move up one page, the page length depends on the size
of the current active window.
2) <PgDn>
Move down one page, the page length depends on the size
of the current active window.
3) <Ctrl-PgUp>
Move to the top of the file.
4) <Ctrl-PgDn>
This command will move you to the bottom of the file.
5) Up arrow
Move up one line.
6) Down arrow
Move down one line.
7) Home
This command will move you to the top of the screen.
8) End
This command will move you to the bottom of the screen.
9) Ctrl-J/goto record
This command will ask you the line number(record number)
you want to go. By entering the line number and press
<Enter>, DbfEdit will jump to that line number and highlight
that line.
╔═════ Goto Record ══════╗
║ ║
║ Enter record no. 100 ║
║ ║
╚════════════════════════╝
Dbase Editor
If the line number you entered is larger than
the total records in the database, an error message will
pop-up to warn you.
┌────────────── Message ──────────────┐
│ The value exceed the total recrods │
│ ╔════╗ │
│ ║ OK ║ │
│ ╚════╝ │
└─────────────────────────────────────┘
10) <Ctrl-QF>
This command will search the whole database file for
one specific string of characters. The program will ask
you for the string of characters you want to search.
You can see the following screen.
╔════════════════════════════════ Find ════════════════════════════════╗
║ ║
║ Enter string to SEARCH : noodle ║
║ ║
╚══════════════════════════════════════════════════════════════════════╝
After entering the desired string of characters and
press <Enter>, the program will ask you what field in the
database file you want to search. At this time you can
see the following window.
┌── Fields ──┐
│ =ALL= │
│ NAME │
│ NATURE │
│ ART │
│ COMMODITY │
│ SPECIFIC │
│ MEASURE │
│ NTWT │
│ GRWT │
│ UNIT │
│ COST │
│ SALES │
│ DATE │
│ REMARKS │
└────────────┘
You can now choose a particular field to search or
you can choose =ALL= to choose the whole file for
the specified string.
Dbase Editor
Note that this command always ignore the case that is
the capital or lowercase of the search string.
In the next version, I will add a command allows you
to specific what kind of search you want to perform.
If the program cannot find that string, an error message
will pop-up to warn you.
┌──────────── Message ────────────┐
│ Cannot find the key in the file │
│ ╔════╗ │
│ ║ OK ║ │
│ ╚════╝ │
└─────────────────────────────────┘
11) <F6>/<Ctrl-L>
This command will continue to search the database file
for the string you entered in the previous search.
If there is a match, it will as usual position the
highlight bar on that record. Otherwise, the same
error message will pop-up.
Dbase Editor
B l o c k C o m m a n d s
---------------------------
Key Action
------------------------------------------------
CTRL-KB Mark beginning of block
CTRL-KK Mark end of block
CTRL-KA Mark all records
CTRL-KH Toggle block marking on and off
CTRL-KD Delete marked block
CTRL-KR Recall marked block
CTRL-KC Copy marked block
CTRL-KP Print marked block
To facilitate the manipulation of the data in the database,
a family of block commands is provided. DBFEDIT contains a
complete set of block commands. This includes the commands
to mark the beginning of line, the end of line and all of the
lines. You can then issue the command to delete the marked
block, recall them, copy them or print them to printer. The
very first step is to choose the required block by marking
the beginning and ending of it on the screen using the keys
CTRL-KB and CTRL-KK. The beginning and ending line can be
marked in either order. There is no effect when only one
of the beginning and an end is marked.
However, if the beginning mark is after the ending mark, then
nothing will happen on the screen. The block is shown by a
reversal of video attributes. If you don't want the marked
block be shown on the screen, you can press CTRL-KH to toggle
the display of marked block on and off.
You can also mark the entire file by choose <Mark all>
in the menu or press Ctrl-KA. The program will highlight
all the records in the file.
Dbase Editor
What can be done with a block once it is marked ?
You can use the delete block, recall block, copy block
or print block commands to manipulate the blocks directly.
The keyboard command are CTRL-KD, CTRL-KR, CTRL-KC and
CTRL-KP respectively. You can also choose these commands
from the pull-down menu.
When you press the delete block command (CTRL-KD), the
highlighted block will be marked as deleted. When you
later move the highlighted bar on those records, you can
see 'Del' in the center of the status line.
You can press <Ctrl-KR> to recall all the records in the
marked block. If records are not previously deleted then
no action will be done on those records.
You can also press <Ctrl-KC> to copy the marked block to
the current line of record. Note that because of different
fields between database files, you cannot copy the whole
block from one database file to another. However, you can
use the command CUT & PASTE to copy fields between different
database files.
If you want to print the marked block to the printer, you can
press the key <Ctrl-KP>. If the printer is not ready, a pop-up
message will appear and allow you to choose the action -
try again or abort.
Dbase Editor
W i n d o w C o m m a n d s
-----------------------------
DBFEDIT allows you to view several files at the same time
through the use of windows. Each window can be resize to
any size you like and you can also move them to different
position on the screen. At the present version, totally
20 database files are allowed to open at the same time.
To create a window, you can press <F3> or choose the
Open command from the pull-down menu. The file you choose
will show on the screen with full size. You can then resize
it to suit your needs. Note that you can browse one file
on diferent window, the changes in one window will be
shown on the other window.
Note that if you open more than one file, the program
will automatically adjust the size of screen of the
first file you open so that you can see both of them
at the same time. The first file will be on the
top part of the screen and the second file will be on
the second part of the screen. All file open later
will also open on the lower part of the screen.
To move to the next window, you can simply press <F8>.
If the currently active window is already the last
window you load, then no action will be taken.
To move to the previous window, you can simply press <F7>.
If the currently active window is the first window you opened,
then no active will be taken.
In version 1.2 of DBFEDIT, I have added the vertical scroll
bar on the right of the window to give the user an idea
which part of text they are in. This is a very helpful
features since the user may get lost after scrolling around
the long text.
Dbase Editor
To resize the window, you can press <Ctrl-S> or choose the
Resize command in the pull-down menu. Upon entering this
command, you can press Up arrow, Down arrow, Left arrow and
Right arrow to move the bottom line and the right line. To
move the top line and left line, you can press space bar
once. Pressing the space bar again allows you to change the
top line and right line again. To confirm your change, press
<Enter> once, to abort it, press <ESC> instead.
To move the window, you can press <Ctrl-M> or choose the
Move command in the pull-down mnu. Upon entering this
command, you can see the window frame on the screen. You
can move it by press the arrow keys. To confirm your change,
press <Enter>, to abort it, press <ESC>
Actually, there is another command to facilitate your
moving from one window to another window. You can press
<Ctrl-G> or choose the appropriate option in the pull-down
menu. After that, you will see a window showing all the
filename you have opened. You can go to any file by
using the up arrow and down arrow keys to choose the
filename you want to edit.
To close the current active window, you can press <F2> or
choose the appropriate function in the pull-down menu.
All the memory allocated for that file will be released.
Dbase Editor
E d i t a n d A p p e n d R e c o r d
-------------------------------------------
If you want to edit a record, you can move the highlight bar
to that record and press <Enter>. After you press <Enter>
a pop-up window will appear with all the fields on the left hand
side and the contents of that field on the right hand side.
The following is the sample edit window.
Note the difference of help line at the bottom of the screen.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PH╔════════════════════ DBASE EDITOR ═════════════════════╗
║LEE SENG H║ ║ ▒
║LEE SENG H║ NAME HARBOUR PHONIX ║ ▒
║GAI FAT HO║ NATURE SAUCE ║ ▒
║YAU SHING ║ ART 5OZX12 ║ ▒
║SUN FUNG ║ COMMODITY WORCESTER SAUCE ║ ▒
║TAI SHING ║ SPECIFIC 5OZX12 ║ ▒
║CHAN YEE J║ MEASURE 20.719.3X15.5 ║ ▒
║AU'S ║ NTWT 1.7 ║ ▒
║ON LEE ║ GRWT 4.3 ║ ▒
║TIEN CHU ║ UNIT DOZ ║ ░
║SHING CHEO║ ║ ▒
║LAIN LAIN ╚════════════════════════════════════════════════════════╝ ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
C:\DBFEDIT\
F1-Help F10-End ESC-Abort Home End PgUp PgDn Ctl-PgUp Ctl-PgDn INS DEL
--------------------------------------------------------------------------------
There are several keys you can use to edit the record.
1) <F1>
To pop-up a help screen, listing all the commands you can use.
2) <Ctrl-T>
To delete a word in the fields
Dbase Editor
3) <Ctrl-Right Arrow>
To move to the right of word. If there is no more word on
the right, then you will move to the next field.
4) <Ctrl-Left Arrow>
To move to the left of word. If there is not more word on the
left, then you will move to the previous field. If you
are already in the first field, then no action will be taken.
5) <PgUp>
Move up one field
6) <PgDn>
Move down one field
7) <Ctrl-PgUp>
Move to the first field
8) <Ctrl-PgDn>
Move to the last field
9) <TAB>
Move donw one field
10) <Enter>
Move down one field
11) Up Arrow
Move up one field
12) Down Arrow
Move down one field
13) <DEL>
Delete the character on the current cursor position
14) <INS>
Toggling the insert mode
15) <Home>
move to the leftmost of the current field
16) <End>
Move to the rightmost of the current field
17) <F10>
To confirm your change and return to browse
18) <ESC>
To abort the change and return to browse, the part you
have changed will be lost.
Dbase Editor
Here show one of the help screen you will see in edit mode.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PH╔════════════════════ DBASE EDITOR ═════════════════════╗
║LEE SENG ┌─────────────────Dbase Editor Help Screen─────────────────┐ ▒
║LEE SENG │ │ ▒
║GAI FAT H│ Dbase Editor - by Preston Lau │ ▒
║YAU SHING│ ----------------------------------------------------- │ ▒
║SUN FUNG │ Up one field │ ▒
║TAI SHING│ Down one field │ ▒
║CHAN YEE │ Left one character │ ▒
║AU'S │ Right one character │ ▒
║ON LEE │ F10 Exit with change │ ▒
║TIEN CHU │ ESC Exit without change │ ░
║SHING CHE│ HOME Left most character │ ▒
║LAIN LAIN│ END Right most character │ ▒
║LAIN YOU │ │ ▒
║LAIN YOU │ Press <PgDn> for next page │ ▒
║TONG FOOK└──────────────────────────────────────────────────────────┘
╚══════════════════════════════════════════════════════════════════════════════╝
C:\DBFEDIT\
F1-Help F10-End ESC-Abort Home End PgUp PgDn Ctl-PgUp Ctl-PgDn INS DEL
--------------------------------------------------------------------------------
Special points you should note when you are in the edit mode.
1) If the field is CHARACTER, then characters, numbers and
spaces are also allowed to enter in the field.
2) Only numbers and spaces are allowed in the Numberic field.
3) You can only enter numeric numbers in the Date fields
4) If the day of Date field is greater than 31, then the
program will automatically change it to 31.
5) If the month of Date field is greater than 12, then
the program will automatically change it to 12.
6) If nothing is entered in the numeric field, 0 is assumed.
for example, if the length of the nubmer field is 7
and the decimal places are 3 then 0.000 is assumed.
7) There is a maximum 80 character in the fields. If the database
file contain a field with more than 80 characters, then
you are not allowed to edit any record in that file.
8) You are not allowed to enter anything in the memo field.
That means you cannot edit the memo data.
Dbase Editor
Note that if you previously use the change order function
to change the order of fields in the current file. Or you
choose only part of the fields to display. The append record
screen will be different.
Here is the sample screen for changing the order of fields.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PHONIX SAUCE ┌──── Fields ─────┐
║LEE SENG HING SAUCE │ NAME ▒
║LEE SENG HING SAUCE │ NATURE ▒ ▒
║GAI FAT HONG POWDER │ 1 ART ▒ ▒
║YAU SHING HONG NOODLE │ 2 COMMODITY ▒ ▒
║SUN FUNG PROVISIONS │ SPECIFIC ░ ▒
║TAI SHING PROVISIONS │ MEASURE ▒ ▒
║CHAN YEE JAI CAKE │ NTWT ▒ ▒
║AU'S FL │ GRWT ▒ ▒
║ON LEE NOODLE │ 3 UNIT ▒ ▒
║TIEN CHU SAUCE │ 5 COST ▒ ░
║SHING CHEONG WICKS │ SALES ▒ ▒
║LAIN LAIN PRAWN CRACKER│ 4 DATE ▒ ▒
║LAIN YOU PRAWN CRACKER│ REMARKS ▒
║LAIN YOU PRAWN CRACKER└─────────────────┘ ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
Press <F10> to confirm or press <ESC> to abort
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
The order in this case is 1) ART
2) COMMODITY
3) UNIT
4) DATE
5) COST
If you want to append a new record to the database, you can
choose the append function in the pull-down menu. A pop-up
window will then appear with all the fields left blank.
After appending a new record to the database, another blank
fields will appear which allows you to enter another new
record. You can enter as many as records you like to the
database. If you want to end the append function, just press
<F10> to confirm the current appending record. Otherwise, press
<ESC> to abort the current appending record.
Dbase Editor
C u t a n d P a s t e
-------------------------
This cut and paste function is very easy to use. It allows you
to cut a particular field for serveral records and then paste
them to another database file. To cut a field, you can press
<Ctrl-X> or choose the appropriate function in the pull-down
menu. You will be asked for the field number you want to cut.
If you don't know the field number, then you can press
<Up Arrow> or <Down Arrow> to get a list of fields. Note
that before choosing the cut options, you have to mark
the records to cut. <Ctrl-KB> to mark the beginning of block
and <Ctrl-KK> to mark the ending of block.
After cutting the data, you can then move to another database
file to paste them. Move to the location of recrods from
which you want to paste the previous cutting. You can press
<Ctrl-V> or choose the appropriate function in the pull-down
menu. Note that you cannot paste to different fields.
For example, if you cut a character field, you MUST paste
it to a character field also. Note also that without the
previous cut, you cannot execute the paste command.
Dbase Editor
S t a t i s t i c a l F u n c t i o n s
-----------------------------------------
You can use the DBFEDIT to find out the maximum and minimum
value in the particular numeric field of the current
database. You can also find out the sum, mean, standard
deviation and variance by pressing just one key!
Note that you have to specify the range of operation before
issuing the command.
Shown below are the sample calculation using the sample
file SAMPLE2.DBF on the field UNITPRICE of all the records
in the database.
┌─────────────────── Max & Min ───────────────────┐
│ │
│ Max Rec : 24 Max Value : 5238.00 │
│ Min Rec : 146 Min Value : 2.20 │
│ │
│ Press any key to continue │
└─────────────────────────────────────────────────┘
┌────────────────── Sum & Mean ───────────────────┐
│ │
│ Sum : 51269.30 │
│ Mean : 256.35 │
│ │
│ Press any key to continue │
└─────────────────────────────────────────────────┘
┌───────── Standard Deviation & Variance ─────────┐
│ │
│ Std. Deviation : 572.67 │
│ Variance : 327953.87 │
│ │
│ Press any key to continue │
└─────────────────────────────────────────────────┘
┌───────────────────── Mode ──────────────────────┐
│ │
│ Mode : PLASTIC │
│ No. of count : 28 │
│ │
│ Press any key to continue │
└─────────────────────────────────────────────────┘
Dbase Editor
S o r t F i l e
-----------------
To sort a file, you can choose the Sort File option from
the pull-down menu. After that you will see two pop-up
windows, one asking for the name to save the sorted database,
another asking for the order in which the database is sorted.
Here shown the sample order window for the sorting function.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PHONIX SAUCE ┌──── Fields ─────┐
║LEE SENG HING SAUCE │ 1 NAME ▒
║LEE SENG HING SAUCE │ 6 NATURE ▒ ▒
║GAI FAT HONG POWDER │ ART ░ ▒
║YAU SHING HONG NOODLE │ COMMODITY ▒ ▒
║SUN FUNG PROVISIONS │ 2 SPECIFIC ▒ ▒
║TAI╔════════════════════ Save │ MEASURE ▒ as ═════════════════════╗ ▒
║CHA║ │ NTWT ▒ ║ ▒
║AU'║ Name of file to SAVE : │ GRWT ▒ ║ ▒
║ON ║ │ UNIT ▒ ║ ▒
║TIE╚══════════════════════════│ 3 COST ▒═════════════════════════╝ ░
║SHING CHEONG WICKS │ 4 SALES ▒ ▒
║LAIN LAIN PRAWN CRACKER│ 5 DATE ▒ ▒
║LAIN YOU PRAWN CRACKER│ REMARKS ▒
║LAIN YOU PRAWN CRACKER└─────────────────┘ ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
Press <F10> to confirm or press <ESC> to abort
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
F i l t e r F i l e
---------------------
To filter a file, you can choose the Filter File option
from the pull-down menu or Press Alt-T from the keyboard.
After that you will see a pop-up window asking for the field
number to filter. 1 represent the first field etc.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PHONIX SAUCE 5OZX12
║LEE SENG HING SAUCE 650MLx18 ▒
║LEE SENG HING SAUCE 340MLx36 ▒
║GAI FAT HONG POWDER 6LBX6 ▒
║YAU SHING HONG NOODLE CUP ▒
║SUN FUNG PROVISIONS S.FISH ▒
║TAI SHING PROVISION╔════════ Filter ════════╗ ▒
║CHAN YEE JAI CAKE ║ ║ ▒
║AU'S FL ║ Enter Field no. : 11 ║ ▒
║ON LEE NOODLE ║ ║ ▒
║TIEN CHU SAUCE ╚════════════════════════╝ ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
Press <Up Arrow> or <Down Arrow> to choose the field
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
If you don't know the exact field number, you can press
<Up Arrow> or <Down Arrow> to pop-up a window of fields
to choose.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PHONIX SAUCE ┌── Fields ──┐
║LEE SENG HING SAUCE │ NAME ▒
║LEE SENG HING SAUCE │ NATURE ░ ▒
║GAI FAT HONG POWDER │ ART ▒ ▒
║YAU SHING HONG NOODLE │ COMMODITY ▒ ▒
║SUN FUNG PROVISIONS │ SPECIFIC ▒ ▒
║TAI SHING PROVISION╔═════│ MEASURE ▒═════╗ ▒
║CHAN YEE JAI CAKE ║ │ NTWT ▒ ║ ▒
║AU'S FL ║ Ente│ GRWT ▒ ║ ▒
║ON LEE NOODLE ║ │ UNIT ▒ ║ ▒
║TIEN CHU SAUCE ╚═════│ COST ▒═════╝ ░
║SHING CHEONG WICKS │ SALES ▒ ▒
║LAIN LAIN PRAWN CRACKERS │ DATE ▒ ▒
║LAIN YOU PRAWN CRACKERS │ REMARKS ▒
║LAIN YOU PRAWN CRACKERS └────────────┘ ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
After that you can choose the method to compare.
You can choose Greater than, Smaller than, Greater
than or equal to, Smaller than or equal to, equal to.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PHONIX SAUCE 5OZX12
║LEE SENG HING SAUCE 650MLx18 ▒
║LEE SENG HING SAUCE 340ML┌──── Comparison ────┐ ▒
║GAI FAT HONG POWDER 6LBX6│ Greater Than │ ▒
║YAU SHING HONG NOODLE CUP │ Smaller Than │ ▒
║SUN FUNG PROVISIONS S.FIS│ Greater Than Equal │ ▒
║TAI SHING PROVISIONS D.SQU│ Smaller Than Equal │ ▒
║CHAN YEE JAI CAKE ALMON│ Equal To │ ▒
║AU'S FL 365-6└────────────────────┘ ▒
║ON LEE NOODLE 500GX50 ▒
║TIEN CHU SAUCE 650MLX24 ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
After that another window will pop-up to ask for the
string to filter. Show below is a sample pop-up window.
╔═══════════════════════════════ Filter ═══════════════════════════════╗
║ ║
║ Enter string to FILTER : 1000 ║
║ ║
╚══════════════════════════════════════════════════════════════════════╝
Note that every time you type F9, the program will
search for the next record satifying the condition until
no more record can be found. Therefore, you can first
go to the first record, specify the condition and
keep on pressing F9 to view continuously the records
satisfying your given condition.
If you want to know the current filter expression, you
can choose <View Expression> in the pull-down menu or press
Alt-Y. The window may appear like this.
┌──────────────────────── Filter Expression ─────────────────────────┐
│ │
│ Expression : SALES is smaller than 1000 │
│ │
│ Press any key to continue │
└────────────────────────────────────────────────────────────────────┘
Dbase Editor
G r a p h P l o t t i n g
---------------------------
To plot a graph of a particular field in the currently
active database file, you can choose the <Draw line Graph>
function in the pull-down menu. All you need to do is
choose the field you want to plot at the same time on
the graph. If you choose a field, a tick will be shown
on the left of the chosen field. After finish choosing
the field, you can choose the last object =PLOT= to draw
the graph. Note that only numeric fields will be shown in
the field listing and you can plot at most 7 different
fields on the same graph. One sample screen is shown below.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PHONIX SAUCE ┌─── Fields ───┐
║LEE SENG HING SAUCE │ COST ▒
║LEE SENG HING SAUCE │ SALES ░ ▒
║GAI FAT HONG POWDER │ =PLOT= ▒
║YAU SHING HONG NOODLE └──────────────┘ ▒
║SUN FUNG PROVISIONS S.FISH ▒
║TAI SHING PROVISIONS D.SQUID ▒
║CHAN YEE JAI CAKE ALMOND ▒
║AU'S FL 365-6 ▒
║ON LEE NOODLE 500GX50 ▒
║TIEN CHU SAUCE 650MLX24 ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
At present, five different kinds of graph are supporting.
They are line graph, bar graph, stack graph, HILO graph
and Cubic spline graph. If you want other specific graphing
technique, you can send me the suggestions through mail.
Note that the Bar, stack, HILO and Cublic Spline graphs
are disabled in the shareware version.
After drawing the graph, the program will ask you whether
you want to save the graph to the disk. If so, you can
press <F2>, otherwise, you can press other key to continue.
After pressing the <F2> key, you will be asked for the
file name to save. After entering the filename, the program
will start saving the graph in GIF format.
If you want to change the name of the title, x-axis or y-axis
of the graph, you can choose the appropriate function in the
pull-down menu. You will be allowed to change the title which
is up to 30 characters.
The sample screen is shown below.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PHONIX SAUCE 5OZX12
║LEE SENG HING SAUCE 650MLx18 ▒
║LEE SENG HING SAUCE 340MLx36 ▒
║GAI FAT HONG POWDER 6LBX6 ▒
║YAU SHING HONG NOODLE CUP ▒
║SUN FUNG PROVISIONS S.FISH ▒
║TAI SHING ╔═══════════════════ Change Graph Title ════════════════════╗ ▒
║CHAN YEE J║ Press F10 to return, ESC to abort ║ ▒
║AU'S ║ ║ ▒
║ON LEE ║ Enter new graph title : Dbase Editor Version 1.2 ║ ▒
║TIEN CHU ║ Enter new x-axis title : X-AXIS ║ ░
║SHING CHEO║ Enter new y-axis title : Y-AXIS ║ ▒
║LAIN LAIN ╚═══════════════════════════════════════════════════════════╝ ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
S p e c i a l C o m m a n d s
-------------------------------
1) When you press 'F1', a help screen will pop-up and you
can press PAGE-DOWN to see next page or PAGE-UP to
see the previous page. One of the help screen is shown
below.
┌──────────────── Dbase Editor Help Screen ────────────────┐
│ │
│ Dbase Editor - by Preston Lau │
│ ----------------------------------------------------- │
│ Up one field │
│ Down one field │
│ Left one character │
│ Right one character │
│ F10 Exit with change │
│ ESC Exit without change │
│ HOME Left most character │
│ END Right most character │
│ │
│ Press <PgDn> for next page │
└──────────────────────────────────────────────────────────┘
2) When you choose the Shell-to-DOS command in the pull-down
menu or press Alt-O. You can see the following screen.
--------------------------------------------------------------------------------
Enter <exit> to return to the editor
The IBM Personal Computer DOS
Version 3.30 (C)Copyright International Business Machines Corp 1981, 1987
(C)Copyright Microsoft Corp 1981, 1986
C:\DBFEDIT>
C:\DBFEDIT>exit
|
|
|
If you type 'exit' here,
you will be back to the dbase editor.
--------------------------------------------------------------------------------
Dbase Editor
3) To change the default color setting, you can press <Alt-S>
or choose the <Change Color> function in the pull-down menu.
After press the key, the following screen will pop-up.
|
|
|
---------------------- | -------------------------------------------------------
╒═════════════════════ | ══════════════════════════════════════════════════════╕
│ D B | E E D I T O R V E R S I O N 1.2 │
│ | Program written by Preston Lau │
╘═════════════════════ | ══════════════════════════════════════════════════════╛
Current : 46 v C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME══════════┌─── Colors ────┐═══ART═════════════════════════════════════════╗
║HARBOUR PHONIX│ Normal Text │ 5OZX12
║LEE SENG HING │ Marked Block │ 650MLx18 ▒
║LEE SENG HING │ Current Line │ 340MLx36 ▒
║GAI FAT HONG │ Prompt Line │ 6LBX6 ▒
║YAU SHING HONG│ Prompt Frame │ CUP ▒
║SUN FUNG │ Entry Line │ S.FISH ▒
║TAI SHING │ Error Message │ D.SQUID ▒
║CHAN YEE JAI │ Menu Text │ ALMOND ▒
║AU'S │ Menu Select │ 365-6 ▒
║ON LEE │ Menu Frame │ 500GX50 ▒
║TIEN CHU │ Logo Text │ 650MLX24 ░
║SHING CHEONG │ Logo Frame │ WICKS ▒
║LAIN LAIN │ Header Line │ GP ▒
║LAIN YOU │ Footer Line │ HM ▒
║LAIN YOU │ Help Line │ PIGEON ▒
║TONG FOOK └───────────────┘ 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
You can now use up arrow and down arrow to choose one
and change it to you favourite color! After that, you can
choose <Save Config> to save it.
Dbase Editor
4) Get Info - You can press <Alt-I> or choose the appropriate
function in the pull-down menu. After choosing it, a window
will pop-up and it show you all the information of the
current active database. You can press <PgDn> to go to
next page or <PgUp> to go to previous page.
A sample window is shown below.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63
╔NAME═════┌──────────── Dbase Editor Information Screen ─────────────┐═════════╗
║HARBOUR P│ │
║LEE SENG │ Filename : C:\DBFEDIT\SAMPLE1.DBF │ ▒
║LEE SENG │ Fields : 13 │ ▒
║GAI FAT H│ Record Size : 178 │ ▒
║YAU SHING│ Records : 63 │ ▒
║SUN FUNG │ Last Update : 01/21/90 │ ▒
║TAI SHING│ Free memory : 169480 bytes (165 K) │ ▒
║CHAN YEE │----------------------------------------------------------│ ▒
║AU'S │ # FIELD NAME TYPE LEN DEC │ ▒
║ON LEE │ 6 MEASURE C 15 0 │ ▒
║TIEN CHU │ 7 NTWT C 5 0 │ ░
║SHING CHE│ 8 GRWT C 5 0 │ ▒
║LAIN LAIN│ 9 UNIT C 8 0 │ ▒
║LAIN YOU │ 10 COST N 8 2 │ ▒
║LAIN YOU │ │ ▒
║TONG FOOK│ <PgUp> for prior page, or <PgDn> for next page │
╚═════════└──────────────────────────────────────────────────────────┘═════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
5) Pop-up Calculator - You can press <Alt-C> or choose the
appropriate function in the pull-down menu. After
choosing it, a window will pop-up and you can now enter
the expression to calulate.
Note that parenthesis are allowed in the expression.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 sample1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PHONIX SAUCE 5OZX12
║LEE SENG HING SAUCE 650MLx18 ▒
║LEE SENG HING SAUCE 340MLx36 ▒
║GAI FAT HONG POWDER 6LBX6 ▒
║YAU SHING HONG NOODLE CUP ▒
║SUN FUNG PROVISIONS S.FISH ▒
║TAI╒═════════════════════════════ Calculator ═════════════════════════════╕ ▒
║CHA│ │ ▒
║AU'│ Enter Expression : 6+(12*2-20)*3 │ ▒
║ON │ The result is : 18.00 │ ▒
║TIE│ │ ░
║SHI│ Press <ESC> to quit │ ▒
║LAI╘══════════════════════════════════════════════════════════════════════╛ ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
6) If you want to copy the structure of the current active
file, you can choose <Copy Structure> in the pull-down
menu. One sample screen is shown below.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 sample1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PHONIX SAUCE 5OZX12
║LEE SENG HING SAUCE 650MLx18 ▒
║LEE SENG HING SAUCE 340MLx36 ▒
║GAI FAT HONG POWDER 6LBX6 ▒
║YAU SHING HONG NOODLE CUP ▒
║SUN FUNG PROVISIONS S.FISH ▒
║TAI╔═══════════════════════════ Copy Structure ═══════════════════════════╗ ▒
║CHA║ ║ ▒
║AU'║ Name of file to WRITE : test.dbf ║ ▒
║ON ║ ║ ▒
║TIE╚══════════════════════════════════════════════════════════════════════╝ ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
7) Save as text - This function allows you to save
the marked block of records to a given file name
in ASCII text. Note that you have to mark the
block before issuing the command.
--------------------------------------------------------------------------------
╒══════════════════════════════════════════════════════════════════════════════╕
│ D B A S E E D I T O R V E R S I O N 1.2 │
│ Program written by Preston Lau │
╘══════════════════════════════════════════════════════════════════════════════╛
Current : 46 sample1.DBF Total : 63
╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗
║HARBOUR PHONIX SAUCE 5OZX12
║LEE SENG HING SAUCE 650MLx18 ▒
║LEE SENG HING SAUCE 340MLx36 ▒
║GAI FAT HONG POWDER 6LBX6 ▒
║YAU SHING HONG NOODLE CUP ▒
║SUN FUNG PROVISIONS S.FISH ▒
║TAI╔═════════════════════════ Save as text file ══════════════════════════╗ ▒
║CHA║ ║ ▒
║AU'║ Name of file to SAVE : test.txt ║ ▒
║ON ║ ║ ▒
║TIE╚══════════════════════════════════════════════════════════════════════╝ ░
║SHING CHEONG WICKS WICKS ▒
║LAIN LAIN PRAWN CRACKERS GP ▒
║LAIN YOU PRAWN CRACKERS HM ▒
║LAIN YOU PRAWN CRACKERS PIGEON ▒
║TONG FOOK VERMICELLI 50gx500
╚══════════════════════════════════════════════════════════════════════════════╝
F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit
--------------------------------------------------------------------------------
Dbase Editor
DBASE EDITOR Development History
--------------------------------
Version 1.2 - Released September 15, 1990
-----------------------------------------
1) Allow you to sort the database file and save it to
the disk in another name. You can specify the order
of fields you want to sort.
2) The mode of a particular field can be easily calculated.
All kind of fields are now supported. The number of
occurrence of the value is also shown.
3) You can now reorder the fields in the edit mode.
Any combination of fields can be choosed for editing.
You can also go to the next record and previous record
using the <PgDn> and <PgUp> keys in the EDIT mode.
This helps you a lot when you want to edit a lot of
data.
4) Add the Vertical Scroll bar in the window to indicate
the position of record in the file.
5) Easy scrolling in the get-info function.
You can now use <PgUp> and <PgDn> to scroll the
page of database information up and down easily.
6) Allow you to add multiple records. After pressing the
<F10> key to confirm the change, another empty
record will pop up. As soon as all new records have
been added. You can press <ESC> to abort.
7) Even faster calculating the sum, mean, standard
deviation and mode.
8) Add the HI Lo graph to the graphics functinos.
9) Add the Cublic Splien Graph to the graphics functions.
10) Even better user interface - Use Dialog and new
error message window. Different method to open a
window (open up in the middle).
11) Fix the stop searching bug in version 1.0
12) Fix some minor bugs.
Version 1.0 - Released January 8, 1990
--------------------------------------
1) Cut and Paste function are supported.
Easy manipulation of data between different database
file.
2) Add the draw bar graph function.
3) Add the draw stack graph function.
4) Add the change title function.
5) Add the Save Graph function. Save as GIF format.
6) You can now save the block of records in the database
file as ASCII text format.
7) Add the copy marked block function.
8) Change the function F4 to Mark beginning block.
and F5 to Mark ending block.
9) Some minor modifications.
Version 0.9 - Released October 8, 1989
--------------------------------------
1) Owning to a programming bug, the speed of screen output
is proportional to the number of fields present.
Now, the bug is fixed and so the screen output
is faster.
2) Use a larger file buffer, i.e. faster file access.
3) A graph plotting function is included.
4) A copy structure function is included.
5) Now, the search function can search a particular field.
6) Show current file name in the status line.
Dbase Editor
7) Add the Mark all records function.
8) When you edit more than one file, the program will
automatically change the window size for you.
9) Support Dbase IV and FOXPRO database files.
10) Fix a bug in memo field.
11) Allow you to choose a drive letter from A - Z.
12) Add the record filtering function.
13) Different opening screen.
14) Many minor modification.
Version 0.82 - Released September 8, 1989
-----------------------------------------
1) Faster screen output. More than three times faster.
2) Faster file read. Use a larger file buffer so that
the file access is very much faster. When you press
'PGUP' or 'PGDN', the screen update time is less than a
second!
3) The file search algorithm is improved and faster.
4) Add the view index expression function.
5) Add the calculator function.
6) Add the maximum and minimum function.
7) Add the Sum and Mean function.
8) Add the Standard Deviation and Variance function.
9) Fast calculation. When using a PS-2 model 50 to sum up
a field in a database with 500 records. It takes only
3 SECONDS!!!
10) Fix a bug in the search function.
11) Show free memory space in Get Info.
12) Use Large memory model instead of Small.
13) Many minor bugs.
Dbase Editor
Version 0.8 - Released on August 25, 1989 (1st release)
-------------------------------------------------------
Original Release!